SmartBox Setting
Certain SmartObject property settings can be configured in the K2 SmartBox. The options available will differ depending on the category selected for the property.
The SmartBox Setting is displayed as a button at the top of the SmartObject Properties Toolbar. Click the SmartBox Setting button to open the Advanced SmartBox Settings window.
Fig. 1. SmartBox Settings
| Feature | What it is |
|---|---|
| Key | Creates the column in the database as unique and not nullable * |
| Unique | Creates the record as unique in the database |
| Sort By | This is an order by clause that can be used in the data provider. Selecting this option will create a index for the SQL table. |
| Constant Size Value | Select this check box if the information that is going to be entered has a fixed number, for example a social security number etc. |
| Encrypt Property | Will encrypt the SmartObject data when it is written to the database. The data will be viewable in reports. |
| Maximum Size | Creates a limit on the size on the property field. For example, a maximum size of 30 would only allow 30 characters to be stored in the database. |
| * At least one of the columns within the database must be created as the key | |
Property Encryption
When enabled, this feature encrypts the data stored in SQL Server using the SSO key in the same manner as password encryption of the K2 Server passwords for security identities.
